<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>Snomed Top Hierarchy Concepts</title>
    <meta http-equiv="content-type" content="text/html; charset=Cp1252">
    <style type="text/css">
      body { font-family: verdana, arial, helvetica, sans-serif;
             font-size: smaller; }
      h1 { font-size: large; }
      tr { font-size: smaller; }
      th, td { border-left: 1px solid #000000;
               border-bottom: 1px solid #000000; padding: 2px; }
      th { color: #000000; background: #e9e9f2; }
      table { padding: 0px;  margin: 0px;
              border-top: 1px solid #000000;
              border-right: 1px solid #000000; }
      table.info { color: #000000; background: #e9e9f2; }
      table.data { color: #000000; background: #ffffff; }
      td.label { text-align: right; }
      td.value { font-weight: bold; }
      tr.even { color: #000000; background: #ffffff; }
      tr.odd { color: #000000; background: #eeeeee; }
    </style>
  </head>
  <body>
    <h1>Snomed Top Hierarchy Concepts</h1>
    <p>
      The Concepts that are in the top of the hierarchis of Snomed, remember that the top concept is "SNOMED CT Concept (SNOMED RT+CTV3)" with id 138875005.
    </p>
    <table class="info" cellspacing="0">
      <tr>
        <td class="label">Date:</td>
        <td class="value"><b>2011-03-31 22:20:04</b></td>
      </tr>
      <tr>
        <td class="label">Rows:</td>
        <td class="value"><b>19</b></td>
      </tr>
      <tr>
        <td class="label">Columns:</td>
        <td class="value"><b>2</b></td>
      </tr>
      <tr>
        <td>SQL Statement:</td>
        <td>
          <b><pre>select c.conceptID,c.fullySpecifiedName from snomedes.relationships r,snomedes.concepts c where r.conceptID1=c.conceptID and r.conceptID2='138875005' and r.relationshipType='116680003'</pre></b>
        </td>
      </tr>
    </table>
    <br>
    <table class="data" cellspacing="0">
      <tr>
        <th>conceptID</th>
        <th>fullySpecifiedName</th>
      </tr>
      <tr class="even">
        <td>105590001</td>
        <td>Substance (substance)</td>
      </tr>
      <tr class="odd">
        <td>106237007</td>
        <td>Linkage concept (linkage concept)</td>
      </tr>
      <tr class="even">
        <td>243796009</td>
        <td>Situation with explicit context (situation)</td>
      </tr>
      <tr class="odd">
        <td>260787004</td>
        <td>Physical object (physical object)</td>
      </tr>
      <tr class="even">
        <td>254291000</td>
        <td>Staging and scales (staging scale)</td>
      </tr>
      <tr class="odd">
        <td>308916002</td>
        <td>Environment or geographical location (environment &#47; location)</td>
      </tr>
      <tr class="even">
        <td>123038009</td>
        <td>Specimen (specimen)</td>
      </tr>
      <tr class="odd">
        <td>419891008</td>
        <td>Record artifact (record artifact)</td>
      </tr>
      <tr class="even">
        <td>123037004</td>
        <td>Body structure (body structure)</td>
      </tr>
      <tr class="odd">
        <td>48176007</td>
        <td>Social context (social concept)</td>
      </tr>
      <tr class="even">
        <td>78621006</td>
        <td>Physical force (physical force)</td>
      </tr>
      <tr class="odd">
        <td>71388002</td>
        <td>Procedure (procedure)</td>
      </tr>
      <tr class="even">
        <td>370115009</td>
        <td>Special concept (special concept)</td>
      </tr>
      <tr class="odd">
        <td>363787002</td>
        <td>Observable entity (observable entity)</td>
      </tr>
      <tr class="even">
        <td>373873005</td>
        <td>Pharmaceutical &#47; biologic product (product)</td>
      </tr>
      <tr class="odd">
        <td>410607006</td>
        <td>Organism (organism)</td>
      </tr>
      <tr class="even">
        <td>404684003</td>
        <td>Clinical finding (finding)</td>
      </tr>
      <tr class="odd">
        <td>272379006</td>
        <td>Event (event)</td>
      </tr>
      <tr class="even">
        <td>362981000</td>
        <td>Qualifier value (qualifier value)</td>
      </tr>
    </table>
    <p><i>[ Generated by: DbVisualizer Personal 7.1.3 - <a href="http://www.dbvis.com">http://www.dbvis.com</a> ]</i></p>
    <hr>
  </body>
</html>
